<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2015-07-22
 * Time: 9:30
 */
$db['member_message']=array(
    'columns' =>
    array(
        'message_id' => array(
            'type' =>   'number',
            'required' => true,
            'pkey' => true,
            'extra' => 'auto_increment',
            'comment' => app::get('b2c')->_('我的消息ID'),
        ),
        'member_id' =>  array(
            'type' =>   'number',
            'default'   =>  0,
            'comment' => app::get('b2c')->_('用户ID'),
        ),
        'message_type'  =>  array(
            'type' => "enum('comment','praise','fans','sysmsg')",
            'required' => true,
            'comment' => app::get('b2c')->_('消息类型'),
        ),
        'is_read'   =>  array(
            'type'  =>  'intbool',
            'default'=>'0',
            'required' => true,
            'comment'   =>  app::get('b2c')->_('是否已读'),
        ),
        'time'  =>  array(
            'type'  =>  'cdate',
            'required' => true,
            'comment' => app::get('b2c')->_('添加时间'),
        ),
        'detail' => array(
            'type'  =>  'html',
            'comment' => app::get('b2c')->_('评论内容或系统消息，可为null')
        )
    ),
    'engine' => 'innodb',
    'comment' => app::get('b2c')->_('我的消息内评论，点赞，粉 丝，系统消息'),
);